Use Indexes to optimise my query OR Mysql

welcome to shbcf.ru